package com.example.demo.mapper;

import com.example.demo.entity.Source;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ScatterMapper {

    @Select("select stu_name,gpa,total_score from dashuju")
    List<Source> getDashujuScatter();

    @Select("select stu_name,gpa,total_score from jisuanjiyingyong")
    List<Source> getJisuanjiyingyongScatter();//计算机应用

    @Select("select stu_name,gpa,total_score from ruanjiangongcheng")
    List<Source> getRuanjiangongchengScatter();//软件工程

    @Select("select stu_name,gpa,total_score from ruanjianjishu")
    List<Source> getRuanjianjishuScatter();//软件技术

    @Select("select stu_name,gpa,total_score from wangluogongcheng")
    List<Source> getWangluogongchengScatter();//网络工程

    @Select("select stu_name,gpa,total_score from wangluojishu")
    List<Source> getWangluojishuScatter();//网络技术

    @Select("select stu_name,gpa,total_score from wulianwang")
    List<Source> getWulianwangScatter();//物联网

    @Select("select stu_name,gpa,total_score from xinxiguanli")
    List<Source> getXinxiguanliScatter();//信息管理
}
